USE master
GO

CREATE DATABASE HCBank
GO

CREATE LOGIN [hcbank] 
WITH PASSWORD = N'123456' 
, CHECK_EXPIRATION=ON 
, CHECK_POLICY=ON 
, DEFAULT_DATABASE=[master] 
GO

EXEC master..sp_addsrvrolemember 
	@loginame = N'hcbank'
   ,@rolename = N'sysadmin'
GO

USE HCBank
GO

CREATE USER [hcbank] FOR LOGIN [hcbank] WITH DEFAULT_SCHEMA=[dbo]
GO


